package com.example.demo.mapper.entity;

import lombok.Data;

import javax.persistence.Table;

@Data
@Table(name="student_coupons_view")
public class StudentCouponsView {
    private int studentCouponsId;
    private int studentId;
    private int couponsId;
    private int studentCouponsStatus;
    private String couponsNumber;
    private String acquireDate;
    private String updatedAt;
    private CouponsView couponsName;
    private CouponsView couponsType;
    private CouponsView couponsState;
    private int advertiserId;
    private int userId;
}
/*    sc.id AS 'student_coupons_id',
    sc.student_id AS 'student_id',
    sc.coupons_id AS 'coupons_id',
    sc.status AS 'student_coupons_status',
    sc.coupons_number AS 'coupons_number',
    sc.acquire_date AS 'acquire_date',
    sc.updated_at AS 'updated_at',
    c.coupons_name AS 'coupons_name',
    c.coupons_type AS 'coupons_type',
    c.state AS 'coupons_state',
    c.advertiser_id AS 'advertiser_id',
    a.user_id AS 'user_id'*/